USE [RD_COMMON]
GO

/****** Object:  Index [PK_Sales_Star_Customer]    Script Date: 10/03/2011 15:46:55 ******/
ALTER TABLE [dbo].[Sales_Star_Customer] ADD  CONSTRAINT [PK_Sales_Star_Customer] PRIMARY KEY CLUSTERED 
(
	[CustomerNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_COMMON]
GO

/****** Object:  Index [IX_Sales_Star_CompanyNumber]    Script Date: 10/03/2011 15:46:45 ******/
CREATE NONCLUSTERED INDEX [IX_Sales_Star_CompanyNumber] ON [dbo].[Sales_Star_Customer] 
(
	[CompanyNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Sales_Star_Customer_CustomerNumberID]    Script Date: 10/03/2011 15:46:45 ******/
CREATE NONCLUSTERED INDEX [IX_Sales_Star_Customer_CustomerNumberID] ON [dbo].[Sales_Star_Customer] 
(
	[CustomerNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Sales_Star_Customer_ShipToNumber]    Script Date: 10/03/2011 15:46:45 ******/
CREATE NONCLUSTERED INDEX [IX_Sales_Star_Customer_ShipToNumber] ON [dbo].[Sales_Star_Customer] 
(
	[ShiptoNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Sales_Star_InvoiceToNumber]    Script Date: 10/03/2011 15:46:45 ******/
CREATE NONCLUSTERED INDEX [IX_Sales_Star_InvoiceToNumber] ON [dbo].[Sales_Star_Customer] 
(
	[InvoicetoNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Sales_Star_ParentNumber]    Script Date: 10/03/2011 15:46:45 ******/
CREATE NONCLUSTERED INDEX [IX_Sales_Star_ParentNumber] ON [dbo].[Sales_Star_Customer] 
(
	[ParentNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Sales_Star_ShipToNumber]    Script Date: 10/03/2011 15:46:45 ******/
CREATE NONCLUSTERED INDEX [IX_Sales_Star_ShipToNumber] ON [dbo].[Sales_Star_Customer] 
(
	[ShiptoNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Sales_Star_SoldToNumber]    Script Date: 10/03/2011 15:46:45 ******/
CREATE NONCLUSTERED INDEX [IX_Sales_Star_SoldToNumber] ON [dbo].[Sales_Star_Customer] 
(
	[SoldtoNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

USE [RD_COMMON]
GO

/****** Object:  Index [PK_AR_Star_Customer]    Script Date: 10/03/2011 16:02:03 ******/
CREATE CLUSTERED INDEX [PK_AR_Star_Customer] ON [dbo].[AR_Star_Customer] 
(
	[CustomerNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


/****** Object:  Index [IX_AR_Star_BillToNumber]    Script Date: 10/03/2011 15:48:49 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_BillToNumber] ON [dbo].[AR_Star_Customer] 
(
	[BillToNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_AR_Star_Customer_BillTo_Company]    Script Date: 10/03/2011 15:48:49 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_Customer_BillTo_Company] ON [dbo].[AR_Star_Customer] 
(
	[BillToNumber] ASC,
	[CompanyNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_AR_Star_Customer_CustomerNumberID]    Script Date: 10/03/2011 15:48:49 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_Customer_CustomerNumberID] ON [dbo].[AR_Star_Customer] 
(
	[CustomerNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_AR_Star_CustomerNumber]    Script Date: 10/03/2011 15:48:49 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_CustomerNumber] ON [dbo].[AR_Star_Customer] 
(
	[CustomerNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_AR_Star_ParentNumber]    Script Date: 10/03/2011 15:48:49 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_ParentNumber] ON [dbo].[AR_Star_Customer] 
(
	[ParentNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO